﻿using System;

namespace Jb.Domain
{
    public static class DbObject
    {
        /// <summary>
        /// Contains the Names of the Stored Procedures
        /// </summary>
        public static class SP
        {
            public const String GET_PAGED_JOB_LIST_BY_COMPANY = "dbo.GetPagedJobListByCompany";            

            //public const String GET_CONTENT = "dbo.GetContentList";
            public const String GET_LOOKUP_DATA = "dbo.GetLookupData";
            public const String GET_RESUMES_BY_JOBSEEKER = "dbo.GetResumesByJobSeeker";
            public const String GET_COVERLETTERS_BY_JOBSEEKER = "dbo.GetCoverLettersByJobSeeker";

            public const String GET_PAGED_JOBS_BY_ID = "dbo.GetPagedJobsByID";
            public const String GET_PAGED_FAVOURITE_RESUME_LIST = "dbo.GetPagedFavoriteResumeList"; ///Not Implemented yet
            public const String GET_PAGED_RESUMES_BY_ID = "dbo.GetPagedResumesByID";
            public const String GET_PACKAGE_LIST = "dbo.GetPackageList";
            public const String GET_FEATURED_JOBS_BY_COMPANY = "dbo.GetFeaturedJobsByCompany"; //Can Get jobs of all companies if companyID=0
            public const String GET_CONTACTS_BY_COMPANY = "dbo.GetContactsByCompany";
            public const String GET_PAGED_JOBAPPLICATIONS_BY_JOB = "dbo.GetPagedJobApplicationsByJob";
            public const String GET_PAGED_JOBS_BY_CATEGORY = "dbo.GetPagedJobsByCategory";
            public const String GET_PAGED_JOBAPPLICATIONS_BY_COMPANY = "dbo.GetPagedJobApplicationsByCompany";
            public const String GET_CATEGORY_LIST = "dbo.GetCategoryList";
            public const String GET_CONTENT_LIST = "dbo.GetContentList";
            public const String GET_PAGED_JOBAPPLICATIONS_BY_JOBSEEKER = "dbo.GetPagedJobApplicationsByJobSeeker";
            public const String GET_FAVORITE_JOBS_BY_JOBSEEKER = "dbo.GetFavoriteJobsByJobSeeker";
            public const String GET_INTERVIEWREQUESTS_BY_JOBSEEKER = "dbo.GetInterviewRequestsByJobSeeker";
        }

        /// <summary>
        /// Contains the Names of the Database Functions
        /// </summary>
        public static class Function
        {
            
        }
        
        /// <summary>
        /// Conntains the Names of the Database Views
        /// </summary>
        public static class View
        {

        }
    }
}
